MerchandiseHierarchySalesPlan

Entity Definition

Logical Name : MerchandiseHierarchySalesPlan
Physical Name : CO_MRHRC_SLS_PLN

Budgeted sales for a MerchandiseHierarchy by different ReportingPeriods

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer ReportingPeriod(CA_PRD_RP)
MerchandiseHierarchyGroupID (FK)(PK) Unique system assigned identifier for a group or class of merchandise. ID_MRHRC_GP Identity integer MerchandiseHierarchyGroup(CO_MRHRC_GP)
RevenueCostCenterID (FK)(PK) A unique retailer assigned identifier for an accounting budget, that owns merchandise and is used to track the financial performance of the retail enterprise. ID_CTR_RVN_CST Identity integer RevenueCostCenter(CO_CTR_RVN_CST)
BudgetSalesAmount The total monetary value of sales, including returns which is budgeted for the MerchandisingRevenueCenter during the ReportingPeriod. TP_SLS_NT_SLS_BDG Money decimal(16,5)
ActualSalesAmount The total monetary value of sales, including returns which were made by the MerchandisingRevenueCenter during the ReportingPeriod. TP_SLS_ACT Money decimal(16,5)

Relationships

Parent Entity Verb Phrase Child Entity
MerchandiseHierarchyGroup is tracked by MerchandiseHierarchySalesPlan
RevenueCostCenter defines accounting disposition of MerchandiseHierarchySalesPlan
ReportingPeriod delineates MerchandiseHierarchySalesPlan

Logical Views containing MerchandiseHierarchySalesPlan

Logical View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 03200 - Reporting - Item Sales View
Logical 10200 - Enterprise - Merchandise View